if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_PhieuNhapXuat_GetById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_PhieuNhapXuat_GetById]
GO
CREATE PROC [sp_PhieuNhapXuat_GetById](
	@ID					INT
)
AS
	SELECT 
	ID,
	Ki_hieu,
	Ma_khach_hang,
	Ma_nhan_vien,
	Tong_tien,
	Thue,
	Tien_thue,
	Loai_nhap_xuat,
	Thanh_tien,
	Thanh_toan,
	Chiet_khau,
	Tien_chiet_khau,
	Ma_ngoai_te,
	Ty_gia,
	Tien_no,
	Ma_hinh_thuc_thanh_toan,
	Xuat_hoa_don,
	Ghi_chu,
	Ngay_cap_nhat_cuoi
	FROM PhieuNhapXuat WHERE ID = @ID